package kjh820909.basic;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import oracle.net.nt.ConnStrategy;

public class J23_MemberDAO implements J23_MemberService {

	private static final String DRV ="oracle.jdbc.OracleDriver";
	private static final String URL ="jdbc:oracle:thin:@//localhost:1521/xe";
	private static final String USR ="scott";
	private static final String PWD ="TIGER";
	
	private static final String insertSQL ="";
	private static final String updateSQL ="";
	private static final String deleteSQL ="";
	private static final String selectSQL =
			"select userid,jumin,mp from member "
			+ " order by userid ";
	private static final String selectONESQL =
			"select * from member where userid = ?";
	
	@Override
	public int insertMember(J23_member m) {
		int cnt = 0;
		return cnt;
	}

	@Override
	public int updateMember(J23_member m) {
		int cnt = 0;
		return cnt;
	}

	@Override
	public int deleteMember(String m) {
		int cnt = 0;
		return cnt;
	}

	@Override
	public ArrayList<J23_member> readMember() {
		ArrayList<J23_member> data =
				new ArrayList<J23_member>();
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		try{
			Class.forName(DRV);
			conn = DriverManager.getConnection(URL, USR, PWD);
			ps = conn.prepareStatement(selectSQL);
			rs = ps.executeQuery();
			
			while(rs.next()){
				J23_member m = new J23_member(
						rs.getString(1),rs.getString(2),"","",
						"","",rs.getString(3),"");
				// 결과집합rs에 저장된 모든 데이터 중
				// 레코드 단위(행)로 하나씩 읽어와서
				// J23_member 클래스에 저장하고
				// 그것을ArrayList data변수에 추가함
				data.add(m);
				
			}
			
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			if(rs != null)try{rs.close();}catch(Exception e){}
			if(ps != null)try{ps.close();}catch(Exception e){}
			if(conn != null)try{conn.close();}catch(Exception e){}
		
		}
				
		
		return data;
	}

	@Override
	public J23_member readOneMember(String m) {
		J23_member data = null;
		return data;
	}

}
